CREATE TABLE [dbo].[Publish_Request_Detail]
(
[PublishRequestDetailID] [int] NOT NULL IDENTITY(1, 1),
[PublishRequestID] [int] NOT NULL,
[ContentID] [numeric] (18, 0) NOT NULL,
[PublishRegenerateInd] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Publish_Request_Detail_PublishRegenerateInd] DEFAULT ('P'),
[PublishServerCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Frequency] [int] NOT NULL,
[PublishedDateTime] [datetime] NULL,
[WebsiteKey] [uniqueidentifier] NULL,
[DeleteFlag] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Publish_Request_Detail_DeleteFlag] DEFAULT ('N'),
[PublishRequestStatusCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Publish_Request_Detail_PublishRequestStatusCode] DEFAULT ('N'),
[NumOfAttempts] [int] NOT NULL CONSTRAINT [DF_Publish_Request_Detail_NumOfAttempts] DEFAULT ((0))
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Publish_Request_Detail] ADD CONSTRAINT [PK_Publish_Request_Detail] PRIMARY KEY CLUSTERED ([PublishRequestDetailID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Request_Detail_ContentID] ON [dbo].[Publish_Request_Detail] ([ContentID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Request_Detail_PublishRequestID] ON [dbo].[Publish_Request_Detail] ([PublishRequestID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Request_Detail_PublishRequestStatusCode] ON [dbo].[Publish_Request_Detail] ([PublishRequestStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_Publish_Request_Detail_PublishServerCode] ON [dbo].[Publish_Request_Detail] ([PublishServerCode]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Publish_Request_Detail] ADD CONSTRAINT [FK_PUBLISH__REFERENCE_CONTENT] FOREIGN KEY ([ContentID]) REFERENCES [dbo].[Content] ([ContentID])
GO
ALTER TABLE [dbo].[Publish_Request_Detail] ADD CONSTRAINT [FK_Publish_Request_Detail_Request] FOREIGN KEY ([PublishRequestID]) REFERENCES [dbo].[Publish_Request] ([PublishRequestID])
GO
ALTER TABLE [dbo].[Publish_Request_Detail] ADD CONSTRAINT [FK_Publish_Request_Detail_Server] FOREIGN KEY ([PublishServerCode]) REFERENCES [dbo].[Publish_Server_Ref] ([PublishServerCode])
GO
ALTER TABLE [dbo].[Publish_Request_Detail] ADD CONSTRAINT [FK_PublishRequestDetail_PublishRequestStatus] FOREIGN KEY ([PublishRequestStatusCode]) REFERENCES [dbo].[Publish_Request_Status_Ref] ([PublishRequestStatusCode])
GO
GRANT REFERENCES ON  [dbo].[Publish_Request_Detail] TO [IMIS]
GRANT SELECT ON  [dbo].[Publish_Request_Detail] TO [IMIS]
GRANT INSERT ON  [dbo].[Publish_Request_Detail] TO [IMIS]
GRANT DELETE ON  [dbo].[Publish_Request_Detail] TO [IMIS]
GRANT UPDATE ON  [dbo].[Publish_Request_Detail] TO [IMIS]
GO